Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 525370 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 134.7 MiB |
| Average record size in memory | 268.8 B |
Variable types
| Text | 1 |
|---|---|
| DateTime | 1 |
| Numeric | 9 |
| Categorical | 1 |
Reproduction
| Analysis started | 2024-03-21 02:20:54.147280 |
|---|---|
| Analysis finished | 2024-03-21 02:21:25.034900 |
| Duration | 30.89 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
symbol
Text
| Distinct | 2307 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.3 MiB |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.4161486 |
| Min length | 5 |
Characters and Unicode
| Total characters | 2845482 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | a1101 |
|---|---|
| 2nd row | a1103 |
| 3rd row | a1105 |
| 4th row | a1107 |
| 5th row | a1109 |
| Value | Count | Frequency (%) |
| a1609 | 373 | 0.1% |
| a1809 | 372 | 0.1% |
| a1709 | 371 | 0.1% |
| a1509 | 371 | 0.1% |
| a1209 | 371 | 0.1% |
| a1501 | 370 | 0.1% |
| a1601 | 370 | 0.1% |
| a1701 | 369 | 0.1% |
| a1909 | 369 | 0.1% |
| a1801 | 368 | 0.1% |
| Other values (2297) | 521666 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 573335 | |
| 0 | 481015 | |
| 2 | 390346 | |
| b | 130302 | 4.6% |
| 3 | 126409 | 4.4% |
| p | 107891 | 3.8% |
| 4 | 99895 | 3.5% |
| j | 98039 | 3.4% |
| 9 | 94592 | 3.3% |
| 5 | 91304 | 3.2% |
| Other values (17) | 652354 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2845482 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 573335 | |
| 0 | 481015 | |
| 2 | 390346 | |
| b | 130302 | 4.6% |
| 3 | 126409 | 4.4% |
| p | 107891 | 3.8% |
| 4 | 99895 | 3.5% |
| j | 98039 | 3.4% |
| 9 | 94592 | 3.3% |
| 5 | 91304 | 3.2% |
| Other values (17) | 652354 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2845482 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 573335 | |
| 0 | 481015 | |
| 2 | 390346 | |
| b | 130302 | 4.6% |
| 3 | 126409 | 4.4% |
| p | 107891 | 3.8% |
| 4 | 99895 | 3.5% |
| j | 98039 | 3.4% |
| 9 | 94592 | 3.3% |
| 5 | 91304 | 3.2% |
| Other values (17) | 652354 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2845482 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 573335 | |
| 0 | 481015 | |
| 2 | 390346 | |
| b | 130302 | 4.6% |
| 3 | 126409 | 4.4% |
| p | 107891 | 3.8% |
| 4 | 99895 | 3.5% |
| j | 98039 | 3.4% |
| 9 | 94592 | 3.3% |
| 5 | 91304 | 3.2% |
| Other values (17) | 652354 |
date
Date
| Distinct | 3203 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| Minimum | 2011-01-04 00:00:00 |
|---|---|
| Maximum | 2024-03-11 00:00:00 |
Histogram with fixed size bins (bins=50)
open
Real number (ℝ)
ZEROS
| Distinct | 17452 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2910.7923 |
| Minimum | 0 |
|---|---|
| Maximum | 29600 |
| Zeros | 194199 |
| Zeros (%) | 37.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2010 |
| Q3 | 4680 |
| 95-th percentile | 8901 |
| Maximum | 29600 |
| Range | 29600 |
| Interquartile range (IQR) | 4680 |
Descriptive statistics
| Standard deviation | 3336.5957 |
|---|---|
| Coefficient of variation (CV) | 1.1462844 |
| Kurtosis | 2.9666818 |
| Mean | 2910.7923 |
| Median Absolute Deviation (MAD) | 2010 |
| Skewness | 1.3772142 |
| Sum | 1.5292429 × 109 |
| Variance | 11132871 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 194199 | |
| 3500 | 224 | < 0.1% |
| 3400 | 196 | < 0.1% |
| 3700 | 195 | < 0.1% |
| 4300 | 194 | < 0.1% |
| 4700 | 190 | < 0.1% |
| 3800 | 188 | < 0.1% |
| 4400 | 188 | < 0.1% |
| 3600 | 188 | < 0.1% |
| 8300 | 188 | < 0.1% |
| Other values (17442) | 329420 |
| Value | Count | Frequency (%) |
| 0 | 194199 | |
| 39.5 | 1 | < 0.1% |
| 40.5 | 1 | < 0.1% |
| 40.75 | 2 | < 0.1% |
| 41 | 1 | < 0.1% |
| 41.1 | 1 | < 0.1% |
| 41.2 | 1 | < 0.1% |
| 41.7 | 1 | < 0.1% |
| 41.9 | 1 | < 0.1% |
| 42 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 29600 | 1 | |
| 29500 | 1 | |
| 29430 | 1 | |
| 29350 | 1 | |
| 29150 | 1 | |
| 29000 | 1 | |
| 28945 | 1 | |
| 28880 | 1 | |
| 28865 | 1 | |
| 28800 | 1 |
high
Real number (ℝ)
ZEROS
| Distinct | 17900 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2933.7236 |
| Minimum | 0 |
|---|---|
| Maximum | 30680 |
| Zeros | 194199 |
| Zeros (%) | 37.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2028 |
| Q3 | 4710 |
| 95-th percentile | 8985 |
| Maximum | 30680 |
| Range | 30680 |
| Interquartile range (IQR) | 4710 |
Descriptive statistics
| Standard deviation | 3363.8506 |
|---|---|
| Coefficient of variation (CV) | 1.1466147 |
| Kurtosis | 2.9918832 |
| Mean | 2933.7236 |
| Median Absolute Deviation (MAD) | 2028 |
| Skewness | 1.3807616 |
| Sum | 1.5412903 × 109 |
| Variance | 11315491 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 194199 | |
| 3500 | 188 | < 0.1% |
| 3450 | 167 | < 0.1% |
| 3600 | 167 | < 0.1% |
| 3400 | 154 | < 0.1% |
| 3550 | 151 | < 0.1% |
| 4800 | 150 | < 0.1% |
| 4350 | 147 | < 0.1% |
| 4000 | 146 | < 0.1% |
| 3800 | 144 | < 0.1% |
| Other values (17890) | 329757 |
| Value | Count | Frequency (%) |
| 0 | 194199 | |
| 39.5 | 1 | < 0.1% |
| 40.6 | 1 | < 0.1% |
| 40.75 | 2 | < 0.1% |
| 42 | 2 | < 0.1% |
| 42.05 | 1 | < 0.1% |
| 42.1 | 1 | < 0.1% |
| 42.4 | 1 | < 0.1% |
| 42.9 | 1 | < 0.1% |
| 42.95 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 30680 | 1 | |
| 29805 | 1 | |
| 29435 | 1 | |
| 29430 | 1 | |
| 29380 | 1 | |
| 29325 | 1 | |
| 29250 | 1 | |
| 29140 | 1 | |
| 29115 | 1 | |
| 29000 | 1 |
low
Real number (ℝ)
ZEROS
| Distinct | 17467 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2887.6408 |
| Minimum | 0 |
|---|---|
| Maximum | 28800 |
| Zeros | 194199 |
| Zeros (%) | 37.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1994 |
| Q3 | 4650 |
| 95-th percentile | 8824 |
| Maximum | 28800 |
| Range | 28800 |
| Interquartile range (IQR) | 4650 |
Descriptive statistics
| Standard deviation | 3308.5896 |
|---|---|
| Coefficient of variation (CV) | 1.145776 |
| Kurtosis | 2.9289193 |
| Mean | 2887.6408 |
| Median Absolute Deviation (MAD) | 1994 |
| Skewness | 1.3719854 |
| Sum | 1.5170799 × 109 |
| Variance | 10946765 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 194199 | |
| 3400 | 176 | < 0.1% |
| 3450 | 173 | < 0.1% |
| 3500 | 168 | < 0.1% |
| 3650 | 162 | < 0.1% |
| 4300 | 160 | < 0.1% |
| 3600 | 160 | < 0.1% |
| 3700 | 158 | < 0.1% |
| 3550 | 156 | < 0.1% |
| 4700 | 155 | < 0.1% |
| Other values (17457) | 329703 |
| Value | Count | Frequency (%) |
| 0 | 194199 | |
| 39.5 | 1 | < 0.1% |
| 40.5 | 1 | < 0.1% |
| 40.75 | 2 | < 0.1% |
| 41 | 2 | < 0.1% |
| 41.1 | 1 | < 0.1% |
| 41.15 | 1 | < 0.1% |
| 41.3 | 1 | < 0.1% |
| 41.4 | 1 | < 0.1% |
| 41.7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 28800 | 1 | |
| 28630 | 1 | |
| 28600 | 1 | |
| 28550 | 1 | |
| 28510 | 1 | |
| 28500 | 1 | |
| 28485 | 1 | |
| 28440 | 1 | |
| 28400 | 1 | |
| 28365 | 1 |
close
Real number (ℝ)
| Distinct | 19029 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4320.8067 |
| Minimum | 37 |
|---|---|
| Maximum | 29380 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 37 |
|---|---|
| 5-th percentile | 122.7 |
| Q1 | 1719 |
| median | 3844 |
| Q3 | 6465 |
| 95-th percentile | 9575 |
| Maximum | 29380 |
| Range | 29343 |
| Interquartile range (IQR) | 4746 |
Descriptive statistics
| Standard deviation | 3189.9395 |
|---|---|
| Coefficient of variation (CV) | 0.73827405 |
| Kurtosis | 2.1882776 |
| Mean | 4320.8067 |
| Median Absolute Deviation (MAD) | 2381.5 |
| Skewness | 0.97052292 |
| Sum | 2.2700222 × 109 |
| Variance | 10175714 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 400 | 4988 | 0.9% |
| 373.3 | 1208 | 0.2% |
| 410.6 | 796 | 0.2% |
| 377.9 | 725 | 0.1% |
| 165.6 | 631 | 0.1% |
| 351.8 | 528 | 0.1% |
| 87.05 | 526 | 0.1% |
| 92 | 335 | 0.1% |
| 124.75 | 324 | 0.1% |
| 3390 | 278 | 0.1% |
| Other values (19019) | 515031 |
| Value | Count | Frequency (%) |
| 37 | 5 | |
| 37.4 | 5 | |
| 37.65 | 1 | < 0.1% |
| 38.05 | 1 | < 0.1% |
| 38.9 | 4 | |
| 39.3 | 4 | |
| 39.5 | 3 | |
| 39.75 | 1 | < 0.1% |
| 39.9 | 2 | < 0.1% |
| 40.15 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 29380 | 1 | |
| 29185 | 1 | |
| 28980 | 1 | |
| 28970 | 1 | |
| 28915 | 1 | |
| 28900 | 1 | |
| 28845 | 1 | |
| 28785 | 1 | |
| 28750 | 2 | |
| 28610 | 1 |
volume
Real number (ℝ)
ZEROS
| Distinct | 87904 |
|---|---|
| Distinct (%) | 16.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33105.351 |
| Minimum | 0 |
|---|---|
| Maximum | 3825808 |
| Zeros | 193526 |
| Zeros (%) | 36.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 10 |
| Q3 | 4565 |
| 95-th percentile | 181152.1 |
| Maximum | 3825808 |
| Range | 3825808 |
| Interquartile range (IQR) | 4565 |
Descriptive statistics
| Standard deviation | 133121.83 |
|---|---|
| Coefficient of variation (CV) | 4.0211574 |
| Kurtosis | 86.203849 |
| Mean | 33105.351 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 7.6337436 |
| Sum | 1.7392558 × 1010 |
| Variance | 1.772142 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 193526 | |
| 1 | 18003 | 3.4% |
| 2 | 13323 | 2.5% |
| 3 | 8373 | 1.6% |
| 4 | 6693 | 1.3% |
| 5 | 5324 | 1.0% |
| 6 | 4585 | 0.9% |
| 7 | 3742 | 0.7% |
| 8 | 3348 | 0.6% |
| 10 | 2888 | 0.5% |
| Other values (87894) | 265565 |
| Value | Count | Frequency (%) |
| 0 | 193526 | |
| 1 | 18003 | 3.4% |
| 2 | 13323 | 2.5% |
| 3 | 8373 | 1.6% |
| 4 | 6693 | 1.3% |
| 5 | 5324 | 1.0% |
| 6 | 4585 | 0.9% |
| 7 | 3742 | 0.7% |
| 8 | 3348 | 0.6% |
| 9 | 2882 | 0.5% |
| Value | Count | Frequency (%) |
| 3825808 | 1 | |
| 3763366 | 1 | |
| 3762910 | 1 | |
| 3729249 | 1 | |
| 3709767 | 1 | |
| 3707160 | 1 | |
| 3681688 | 1 | |
| 3596174 | 1 | |
| 3486760 | 1 | |
| 3478432 | 1 |
open_interest
Real number (ℝ)
ZEROS
| Distinct | 107247 |
|---|---|
| Distinct (%) | 20.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38927.294 |
| Minimum | 0 |
|---|---|
| Maximum | 2260091 |
| Zeros | 82449 |
| Zeros (%) | 15.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 95 |
| Q3 | 11181 |
| 95-th percentile | 214095.8 |
| Maximum | 2260091 |
| Range | 2260091 |
| Interquartile range (IQR) | 11179 |
Descriptive statistics
| Standard deviation | 130230.09 |
|---|---|
| Coefficient of variation (CV) | 3.3454699 |
| Kurtosis | 50.761266 |
| Mean | 38927.294 |
| Median Absolute Deviation (MAD) | 95 |
| Skewness | 6.2325508 |
| Sum | 2.0451233 × 1010 |
| Variance | 1.6959877 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 82449 | 15.7% |
| 1 | 28698 | 5.5% |
| 2 | 20968 | 4.0% |
| 3 | 16968 | 3.2% |
| 4 | 11793 | 2.2% |
| 5 | 9167 | 1.7% |
| 6 | 7430 | 1.4% |
| 7 | 6109 | 1.2% |
| 8 | 4610 | 0.9% |
| 10 | 4255 | 0.8% |
| Other values (107237) | 332923 |
| Value | Count | Frequency (%) |
| 0 | 82449 | |
| 1 | 28698 | 5.5% |
| 2 | 20968 | 4.0% |
| 3 | 16968 | 3.2% |
| 4 | 11793 | 2.2% |
| 5 | 9167 | 1.7% |
| 6 | 7430 | 1.4% |
| 7 | 6109 | 1.2% |
| 8 | 4610 | 0.9% |
| 9 | 4191 | 0.8% |
| Value | Count | Frequency (%) |
| 2260091 | 1 | |
| 2240622 | 1 | |
| 2232052 | 1 | |
| 2231971 | 1 | |
| 2224590 | 1 | |
| 2217014 | 1 | |
| 2203099 | 1 | |
| 2191507 | 1 | |
| 2190623 | 1 | |
| 2178391 | 1 |
turnover
Real number (ℝ)
ZEROS
| Distinct | 238483 |
|---|---|
| Distinct (%) | 45.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 174612.98 |
| Minimum | 0 |
|---|---|
| Maximum | 18662757 |
| Zeros | 193526 |
| Zeros (%) | 36.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 52.04 |
| Q3 | 22782.982 |
| 95-th percentile | 905675.34 |
| Maximum | 18662757 |
| Range | 18662757 |
| Interquartile range (IQR) | 22782.982 |
Descriptive statistics
| Standard deviation | 747185.69 |
|---|---|
| Coefficient of variation (CV) | 4.2790959 |
| Kurtosis | 80.681771 |
| Mean | 174612.98 |
| Median Absolute Deviation (MAD) | 52.04 |
| Skewness | 7.8539036 |
| Sum | 9.1736421 × 1010 |
| Variance | 5.5828645 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 193526 | |
| 4 | 86 | < 0.1% |
| 3.7 | 86 | < 0.1% |
| 4.8 | 81 | < 0.1% |
| 4.08 | 78 | < 0.1% |
| 3.6 | 77 | < 0.1% |
| 4.1 | 77 | < 0.1% |
| 4.5 | 74 | < 0.1% |
| 4.3 | 74 | < 0.1% |
| 3.9 | 73 | < 0.1% |
| Other values (238473) | 331138 |
| Value | Count | Frequency (%) |
| 0 | 193526 | |
| 1.05 | 1 | < 0.1% |
| 1.1 | 1 | < 0.1% |
| 1.11 | 2 | < 0.1% |
| 1.12 | 1 | < 0.1% |
| 1.13 | 1 | < 0.1% |
| 1.15 | 3 | < 0.1% |
| 1.16 | 3 | < 0.1% |
| 1.17 | 1 | < 0.1% |
| 1.18 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 18662757.2 | 1 | |
| 17996196.01 | 1 | |
| 17441620.56 | 1 | |
| 16742168.88 | 1 | |
| 16296677.41 | 1 | |
| 16284149.06 | 1 | |
| 16189322.05 | 1 | |
| 16105202.9 | 1 | |
| 16069741.18 | 1 | |
| 16032551.16 | 1 |
settle
Real number (ℝ)
| Distinct | 19117 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4320.7291 |
| Minimum | 37 |
|---|---|
| Maximum | 29100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 37 |
|---|---|
| 5-th percentile | 122.7 |
| Q1 | 1718 |
| median | 3844 |
| Q3 | 6465 |
| 95-th percentile | 9571.55 |
| Maximum | 29100 |
| Range | 29063 |
| Interquartile range (IQR) | 4747 |
Descriptive statistics
| Standard deviation | 3190.0913 |
|---|---|
| Coefficient of variation (CV) | 0.73832245 |
| Kurtosis | 2.1914095 |
| Mean | 4320.7291 |
| Median Absolute Deviation (MAD) | 2381 |
| Skewness | 0.97124402 |
| Sum | 2.2699815 × 109 |
| Variance | 10176683 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 400 | 4980 | 0.9% |
| 373.3 | 1208 | 0.2% |
| 410.6 | 797 | 0.2% |
| 377.9 | 725 | 0.1% |
| 165.6 | 632 | 0.1% |
| 351.8 | 528 | 0.1% |
| 87.05 | 525 | 0.1% |
| 92 | 335 | 0.1% |
| 124.75 | 325 | 0.1% |
| 3390 | 240 | < 0.1% |
| Other values (19107) | 515075 |
| Value | Count | Frequency (%) |
| 37 | 5 | |
| 37.4 | 5 | |
| 37.65 | 1 | < 0.1% |
| 38.05 | 1 | < 0.1% |
| 38.9 | 4 | |
| 39.3 | 4 | |
| 39.5 | 3 | |
| 39.75 | 1 | < 0.1% |
| 39.9 | 2 | < 0.1% |
| 40.15 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 29100 | 1 | |
| 28985 | 1 | |
| 28910 | 1 | |
| 28875 | 1 | |
| 28860 | 1 | |
| 28830 | 1 | |
| 28765 | 1 | |
| 28755 | 1 | |
| 28700 | 1 | |
| 28635 | 1 |
pre_settle
Real number (ℝ)
| Distinct | 19105 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4320.6605 |
| Minimum | 37 |
|---|---|
| Maximum | 30680 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 MiB |
Quantile statistics
| Minimum | 37 |
|---|---|
| 5-th percentile | 122.7 |
| Q1 | 1718 |
| median | 3844 |
| Q3 | 6465 |
| 95-th percentile | 9574 |
| Maximum | 30680 |
| Range | 30643 |
| Interquartile range (IQR) | 4747 |
Descriptive statistics
| Standard deviation | 3190.8033 |
|---|---|
| Coefficient of variation (CV) | 0.73849897 |
| Kurtosis | 2.2138081 |
| Mean | 4320.6605 |
| Median Absolute Deviation (MAD) | 2382 |
| Skewness | 0.97400343 |
| Sum | 2.2699454 × 109 |
| Variance | 10181226 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 400 | 4969 | 0.9% |
| 373.3 | 1213 | 0.2% |
| 410.6 | 800 | 0.2% |
| 377.9 | 726 | 0.1% |
| 165.6 | 635 | 0.1% |
| 351.8 | 530 | 0.1% |
| 87.05 | 529 | 0.1% |
| 92 | 335 | 0.1% |
| 124.75 | 325 | 0.1% |
| 3390 | 239 | < 0.1% |
| Other values (19095) | 515069 |
| Value | Count | Frequency (%) |
| 37 | 5 | |
| 37.4 | 5 | |
| 37.65 | 1 | < 0.1% |
| 38.05 | 1 | < 0.1% |
| 38.9 | 4 | |
| 39.3 | 4 | |
| 39.5 | 3 | |
| 39.75 | 1 | < 0.1% |
| 39.9 | 2 | < 0.1% |
| 40.15 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 30680 | 1 | |
| 29680 | 1 | |
| 29100 | 1 | |
| 28985 | 1 | |
| 28910 | 1 | |
| 28875 | 1 | |
| 28860 | 1 | |
| 28830 | 1 | |
| 28765 | 1 | |
| 28755 | 1 |
variety
Categorical
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 29.3 MiB |
| L | |
|---|---|
| P | |
| V | |
| J | |
| JM | 31886 |
| Other values (16) |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.4161486 |
| Min length | 1 |
Characters and Unicode
| Total characters | 744002 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| L | 38436 | 7.3% |
| P | 38436 | 7.3% |
| V | 38436 | 7.3% |
| J | 37434 | 7.1% |
| JM | 31886 | 6.1% |
| I | 30162 | 5.7% |
| BB | 29804 | 5.7% |
| FB | 29764 | 5.7% |
| PP | 29261 | 5.6% |
| JD | 28719 | 5.5% |
| Other values (11) | 193032 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| l | 38436 | 7.3% |
| p | 38436 | 7.3% |
| v | 38436 | 7.3% |
| j | 37434 | 7.1% |
| jm | 31886 | 6.1% |
| i | 30162 | 5.7% |
| bb | 29804 | 5.7% |
| fb | 29764 | 5.7% |
| pp | 29261 | 5.6% |
| jd | 28719 | 5.5% |
| Other values (11) | 193032 |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 130302 | |
| P | 107891 | |
| J | 98039 | |
| M | 57510 | 7.7% |
| L | 42764 | 5.7% |
| V | 38436 | 5.2% |
| C | 32651 | 4.4% |
| I | 30162 | 4.1% |
| F | 29764 | 4.0% |
| D | 28719 | 3.9% |
| Other values (7) | 147764 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 744002 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 130302 | |
| P | 107891 | |
| J | 98039 | |
| M | 57510 | 7.7% |
| L | 42764 | 5.7% |
| V | 38436 | 5.2% |
| C | 32651 | 4.4% |
| I | 30162 | 4.1% |
| F | 29764 | 4.0% |
| D | 28719 | 3.9% |
| Other values (7) | 147764 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 744002 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 130302 | |
| P | 107891 | |
| J | 98039 | |
| M | 57510 | 7.7% |
| L | 42764 | 5.7% |
| V | 38436 | 5.2% |
| C | 32651 | 4.4% |
| I | 30162 | 4.1% |
| F | 29764 | 4.0% |
| D | 28719 | 3.9% |
| Other values (7) | 147764 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 744002 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 130302 | |
| P | 107891 | |
| J | 98039 | |
| M | 57510 | 7.7% |
| L | 42764 | 5.7% |
| V | 38436 | 5.2% |
| C | 32651 | 4.4% |
| I | 30162 | 4.1% |
| F | 29764 | 4.0% |
| D | 28719 | 3.9% |
| Other values (7) | 147764 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| symbol | date | open | high | low | close | volume | open_interest | turnover | settle | pre_settle | variety | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | a1101 | 2011-01-04 00:00:00 | 3993.0 | 4120.0 | 3993.0 | 4120.0 | 53.0 | 74.0 | 213.08 | 4020.0 | 4040.0 | A |
| 1 | a1103 | 2011-01-04 00:00:00 | 4110.0 | 4135.0 | 4110.0 | 4128.0 | 5.0 | 108.0 | 20.62 | 4123.0 | 4117.0 | A |
| 2 | a1105 | 2011-01-04 00:00:00 | 4355.0 | 4382.0 | 4355.0 | 4367.0 | 1104.0 | 8766.0 | 4827.65 | 4372.0 | 4362.0 | A |
| 3 | a1107 | 2011-01-04 00:00:00 | 4460.0 | 4460.0 | 4444.0 | 4444.0 | 3.0 | 372.0 | 13.35 | 4451.0 | 4449.0 | A |
| 4 | a1109 | 2011-01-04 00:00:00 | 4528.0 | 4545.0 | 4520.0 | 4537.0 | 55262.0 | 103325.0 | 250617.19 | 4535.0 | 4531.0 | A |
| 5 | a1111 | 2011-01-04 00:00:00 | 0.0 | 0.0 | 0.0 | 4521.0 | 0.0 | 120.0 | 0.00 | 4521.0 | 4521.0 | A |
| 6 | a1201 | 2011-01-04 00:00:00 | 4491.0 | 4534.0 | 4491.0 | 4524.0 | 41293.0 | 112097.0 | 186502.88 | 4516.0 | 4502.0 | A |
| 7 | a1203 | 2011-01-04 00:00:00 | 0.0 | 0.0 | 0.0 | 4537.0 | 0.0 | 58.0 | 0.00 | 4537.0 | 4537.0 | A |
| 8 | a1205 | 2011-01-04 00:00:00 | 4599.0 | 4648.0 | 4598.0 | 4634.0 | 10.0 | 229.0 | 46.28 | 4627.0 | 4619.0 | A |
| 9 | b1101 | 2011-01-04 00:00:00 | 0.0 | 0.0 | 0.0 | 4621.0 | 0.0 | 0.0 | 0.00 | 4621.0 | 4621.0 | B |
| symbol | date | open | high | low | close | volume | open_interest | turnover | settle | pre_settle | variety | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 525360 | v2501 | 2024-03-11 00:00:00 | 6110.0 | 6140.0 | 6055.0 | 6088.0 | 2831.0 | 6661.0 | 8612.56 | 6084.0 | 6104.0 | V |
| 525361 | v2502 | 2024-03-11 00:00:00 | 6120.0 | 6130.0 | 6070.0 | 6090.0 | 15.0 | 300.0 | 45.68 | 6091.0 | 6121.0 | V |
| 525362 | y2403 | 2024-03-11 00:00:00 | 0.0 | 0.0 | 0.0 | 7502.0 | 0.0 | 625.0 | 0.00 | 7502.0 | 7502.0 | Y |
| 525363 | y2405 | 2024-03-11 00:00:00 | 7606.0 | 7650.0 | 7586.0 | 7614.0 | 390687.0 | 580930.0 | 2974332.12 | 7612.0 | 7584.0 | Y |
| 525364 | y2407 | 2024-03-11 00:00:00 | 7524.0 | 7568.0 | 7512.0 | 7522.0 | 4676.0 | 16432.0 | 35209.40 | 7528.0 | 7536.0 | Y |
| 525365 | y2408 | 2024-03-11 00:00:00 | 7520.0 | 7546.0 | 7492.0 | 7504.0 | 2091.0 | 6102.0 | 15706.55 | 7510.0 | 7522.0 | Y |
| 525366 | y2409 | 2024-03-11 00:00:00 | 7498.0 | 7514.0 | 7460.0 | 7470.0 | 116484.0 | 228904.0 | 872192.00 | 7486.0 | 7486.0 | Y |
| 525367 | y2411 | 2024-03-11 00:00:00 | 7468.0 | 7486.0 | 7434.0 | 7456.0 | 1137.0 | 7262.0 | 8488.46 | 7464.0 | 7468.0 | Y |
| 525368 | y2412 | 2024-03-11 00:00:00 | 7514.0 | 7558.0 | 7478.0 | 7534.0 | 149.0 | 1692.0 | 1121.43 | 7526.0 | 7524.0 | Y |
| 525369 | y2501 | 2024-03-11 00:00:00 | 7488.0 | 7534.0 | 7444.0 | 7494.0 | 7490.0 | 11201.0 | 56182.86 | 7500.0 | 7478.0 | Y |